# -*- coding: utf-8 -*-
import datetime

import sqlalchemy
from sqlalchemy.orm import Mapped,mapped_column

import models.database

class Music(models.database.OrmBase):
    __tablename__ = 'music'
    id: Mapped[int] = mapped_column(sqlalchemy.BigInteger, primary_key=True)  # 创建表后最好手动改成unsigned
    name: Mapped[str] = mapped_column(sqlalchemy.String(50)) # 音乐名称
    user_uid: Mapped[int] = mapped_column(sqlalchemy.BigInteger) # 点歌用户UID
    user_uname: Mapped[str] = mapped_column(sqlalchemy.String(50)) # 点歌用户昵称
    avatar_url: Mapped[str] = mapped_column(sqlalchemy.String(100)) # 点歌用户头像
    update_time: Mapped[datetime.datetime]